package com.baturu.vin.gm.dal.dao;

import com.baturu.vin.gm.dto.EngineTransmissionDTO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Set;

public interface EngineTransmissionDAO {

    @Select({"<script>" +
            "SELECT id,optionCode,`name`,autoManual,subName,parameter,type,descriptionCn,descriptionEn " +
            "FROM gm_engine_transmission " +
            "WHERE optionCode IN " +
            "<foreach item='item' index='index' collection='optionCodeList' open='(' separator=',' close=')'>" +
            "#{item}" +
            "</foreach>" +
            "</script>"})
    List<EngineTransmissionDTO> findEngineTransmissions(@Param("optionCodeList") Set<String> optionCodeList);

}
